<?php
session_start();
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
<title>Wellcome to Charity Organization!</title>
</head>

<body>
<div id="container">
		<div id="header">
			<h1>Charity<span class="off">Organization</span></h1>
        </div>   
        <div id="menu">
			<ul>
				<a href="Search.php">Back</a>
            </ul>
        </div>
    
		<?php
		$link =mysql_connect('localhost','root','');
		if (!$link) {
			die('Not connected : ' . mysql_error());
		}
		$db_selected = mysql_select_db('seproject', $link);
		if (!$db_selected) {
			die ('Cannot useSeproject : ' . mysql_error());
		}
		$Category=$_POST["Category"];
		$query = mysql_query("SELECT * FROM `seproject`.`product` where `Category`='$Category'");
		$num=mysql_num_rows($query);
		if($num>0)
		{
			?>
			<div id="content">
			<div id="content_main">
        	<table cellspacing="10" border="0"   align="left" bgcolor="#FFFFFF"  bordercolor="#180000" frame="box">  
			<tr>
			<th>Product_ID</th>
			<th>Category</th>
			<th>Price</th>
			<th>Description</th>
			</tr>
			<?php
			for($i=0;$i<mysql_num_rows($query);$i++)
			{
				$a=mysql_fetch_row($query);
				?>
				<tr>
				<td><?php echo $a[0]; ?></td>
				<td><?php echo $a[1]; ?></td>
				<td><?php echo $a[2]; ?></td>
				<td><?php echo $a[3]; ?></td>
				</tr>
				<?php
			}
			?>
			</table>
			</div>
			<?php
		}
		else
		{
			?>
			<div id="content">
			<div id="content_top"></div>
			<div id="content_main">
        	<?php
			echo "Item not found";
			?>
			<a href="Search.php">Back</a>
			</div>
			<div id="content_bottom"></div>
			<?php
		}
		?>
		</div>
        
      </div>
   </div>
</body>
</html>
